CREATE TABLE [dbo].[tb_UsuariosBiblioteca]
(
[idUsuariosBiblioteca] [int] NOT NULL IDENTITY(1, 1),
[Biblioteca] [int] NULL,
[Socios] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SociosActivos] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ImporteCuota] [int] NULL,
[ImporteTotalAñoAnterior] [int] NULL,
[Niñas] [int] NULL,
[Niños] [int] NULL,
[AdolescentesF] [int] NULL,
[AdolescentesM] [int] NULL,
[AdultosF] [int] NULL,
[AdultosM] [int] NULL,
[AdultosMayoresF] [int] NULL,
[AdultosMayoresM] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_UsuariosBiblioteca] ADD CONSTRAINT [PK_tb_UsuariosBiblioteca] PRIMARY KEY CLUSTERED  ([idUsuariosBiblioteca]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_UsuariosBiblioteca] WITH NOCHECK ADD CONSTRAINT [FK_tb_UsuariosBiblioteca_Tb_Biliotecas] FOREIGN KEY ([Biblioteca]) REFERENCES [dbo].[Tb_Biliotecas] ([idbiblioteca])
GO
